Create Bookmark and KPI'S 10
Create Bookmark
Create Slicer visible Bookmark
·
Go to Modeling
·
Select Bookmark and Selection
·
From Bookmark Click Add
·
Click the three dots and Select Rename Slicer visible
·
Click the three dots unselect data
·
Go to the Format button select Action
-
Type -----Bookmark
-
Bookmark ------Slicer visible
Create Slicer Invisible
Bookmark
·
Go to Modeling
·
Select Bookmark and Selection
·
From Bookmark Click Add
·
Click the three dots and Select Rename Slicer Invisible
·
Click the three dots unselect data
·
Hid the Group1 from the selection
·
Click Update from the three dots
·
Go to the Format button select Action
-
Type -----Bookmark
- Bookmark ------Slicer visible
Create KPI’S
· Download the doc and click ok
1. TOTAL MEMBER KPI
STEP 1
·
Go to insert
·
Select Rectangle from Shapes
General
-
X-Position 0
-
Y-Position 264
-
Width 360
-
Height 120
Background
-
Color Black
-
Transparency 78%
Put everything else off
STEP 2
·
Select Card visual
·
Drag and drop Total member
General
-
X-Position 96
-
Y-Position 312
-
Width 144
-
Height 72
Data Label
-
Color Black
-
Text Size 40
Put everything else off
STEP 3
·
Go to insert
·
Select image from a folder
General
-
X-Position 120
-
Y-Position 264
-
Width 144
-
Height 48
Put everything else off
STEP 4
·
Go to insert
·
Select Text box
·
Write TOTAL MEMBER
-
Choose Time New Roman, Text Size 20, and make it Center
Format
text box
General
-
X-Position 120
-
Y-Position 264
-
Width 144
-
Height 48
Background
-
Color Black
- Transparency 78%
2. FIRST RESPONSE KPI
STEP 1
·
Go to insert
·
Select Rectangle from Shapes
General
-
X-Position 360
-
Y-Position 264
-
Width 384
-
Height 120
Background
-
Color Black
-
Transparency 78%
Put everything else off
STEP 2
·
Select Card visual
·
Drag and drop First Response Time
General
-
X-Position 432
-
Y-Position 312
-
Width 168
-
Height 72
Data Label
- Color
-
Text Size 40
·
Select Card visual
·
Drag and drop Response Time Units
General
-
X-Position 576
-
Y-Position 336
-
Width 120
-
Height 48
Data Label
-
Color
Put everything else off
STEP 3
·
Go to insert
·
Select image from Folder
General
-
X-Position 504
-
Y-Position 264
-
Width 96
-
Height 48
Put everything else off
STEP 4
·
Go to insert
·
Select Text box
·
Write FIRST RESPONSE TIME
-
Choose Time New Roman, Text Size 20, and make it Center
Format
text box
General
-
X-Position 120
-
Y-Position 264
-
Width 144
-
Height 48
Background
-
Color Black
- Transparency 78%
3. CONTRIBUTIONS KPI
STEP 1
·
Go to insert
·
Select Rectangle from Shapes
General
-
X-Position 744
-
Y-Position 264
-
Width 336
-
Height 120
Background
-
Color Black
-
Transparency 78%
Put everything else off
STEP 2
·
Select Card visual
·
Drag and drop Total Contributors
General
-
X-Position 840
-
Y-Position 312
-
Width 144
-
Height 72
Data Label
-
Color Black
-
Text Size 40
Put everything else off
STEP 3
·
Go to insert
·
Select image from a folder
General
-
X-Position 840
-
Y-Position 264
-
Width 144
-
Height 48
Put everything else off
STEP 4
·
Go to insert
·
Select Text box
·
Write CONTRIBUTIONS
-
Choose Time New Roman, Text Size 20, and make it Center
Format
text box
General
-
X-Position 744
-
Y-Position 384
-
Width 336
-
Height 48
Background
-
Color Black
-
Transparency 78%
4. TOTAL QUESTIONS
STEP 1
·
Go to insert
·
Select Rectangle from Shapes
General
-
X-Position 1080
-
Y-Position 264
-
Width 336
-
Height 120
Background
-
Color Black
-
Transparency 78%
Put everything else off
STEP 2
·
Select Card visual
·
Drag and drop Total Contributors
General
-
X-Position 1152
-
Y-Position 312
-
Width 192
-
Height 72
Data Label
-
Color Black
-
Text Size 40
Put everything else off
STEP 3
·
Go to insert
·
Select image from Folder
General
-
X-Position 1176
-
Y-Position 240
-
Width 144
-
Height 96
Put everything else off
STEP 4
·
Go to insert
·
Select Text box
·
Write TOTAL QUESTIONS
-
Choose Time New Roman, Text Size 20, and make it Center
Format
text box
General
-
X-Position 1080
-
Y-Position 384
-
Width 336
-
Height 48
Background
-
Color Black
-
Transparency 78%
5. NOT RESPONDED %
STEP 1
·
Go to insert
·
Select Rectangle from Shapes
General
-
X-Position 1416
-
Y-Position 264
-
Width 360
-
Height 120
Background
-
Color Black
-
Transparency 78%
Put everything else off
STEP 2
·
Select Card visual
·
Drag and drop % Of Not Responded Qns
General
-
X-Position 1440
-
Y-Position 312
-
Width 288
-
Height 72
Data Label
-
Color Black
-
Text Size 40
Put everything else off
STEP 3
·
Go to insert
·
Select image from Folder
General
-
X-Position 1536
-
Y-Position 264
-
Width 96
-
Height 48
Put everything else off
STEP 4
·
Go to insert
·
Select Text box
·
Write NOT RESPONDED %
-
Choose Time New Roman, Text Size 20, and make it Center
Format
text box
General
-
X-Position 1416
-
Y-Position 384
-
Width 360
-
Height 48
Background
-
Color Black
-
Transparency 78%
6. CORRECT ANSWERS %
STEP 1
·
Go to insert
·
Select Rectangle from Shapes
General
-
X-Position 1776
-
Y-Position 264
-
Width 336
-
Height 120
Background
-
Color Black
-
Transparency 78%
Put everything else off
STEP 2
·
Select Card visual
·
Drag and drop % of Not Responded
General
-
X-Position 1848
-
Y-Position 312
-
Width 168
-
Height 72
Data Label
-
Color Black
-
Text Size 40
Put everything else off
STEP 3
·
Go to insert
·
Select image from Folder
General
-
X-Position 1872
-
Y-Position 264
-
Width 120
-
Height 48
Put everything else off
STEP 4
·
Go to insert
·
Select Text box
·
Write NOT RESPONDED %
-
Choose Time New Roman, Text Size 20, and make it a center
Format
text box
General
-
X-Position 1776
-
Y-Position 384
-
Width 336
-
Height 48
Background
-
Color Black
- Transparency 78%
7. QUESTIONS PER DAY
STEP 1
·
Go to insert
·
Select Rectangle from Shapes
General
-
X-Position 2112
-
Y-Position 264
-
Width 384
-
Height 120
Background
-
Color Black
-
Transparency 78%
Put everything else off
STEP 2
·
Select Card visual
·
Drag and drop % of Not Responded
General
-
X-Position 2208
-
Y-Position 312
-
Width 168
-
Height 72
Data Label
-
Color Black
-
Text Size 40
Put everything else off
STEP 3
·
Go to insert
·
Select image from Folder
General
-
X-Position 2232
-
Y-Position 264
-
Width 120
-
Height 48
Put everything else off
STEP 4
·
Go to insert
·
Select Text box
·
Write NOT RESPONDED %
-
Choose Time New Roman, Text Size 20, and make it Center
Format
text box
General
-
X-Position 2112
-
Y-Position 384
-
Width 384
-
Height 48
Background
-
Color Black
-
Transparency 78%
How to create a KPI'S
https://www.youtube.com/watch?v=9eKLdujI9_A
How to create a bookmark in power bi
https://www.youtube.com/watch?v=r5anuXCeDRU